package dao;

import java.sql.SQLException;

import dto.PurchaseOrder;


public interface PurchaseOrderDao {
public void add(PurchaseOrder po) throws SQLException, Exception;
	
	public void update(PurchaseOrder po) throws Exception;
	
	public void delete(PurchaseOrder po) throws Exception;
	
	public PurchaseOrder retreive(String conditionField,String ConditionValue) throws Exception ;
	
	public PurchaseOrder[] retreiveArray(String conditionField,String ConditionValue) throws Exception ;
	
	public PurchaseOrder[] retreiveAll() throws Exception ;

	public int getAutoId();

	public double getPoQty(String poNo, String mCode, int autoSpecCode);
	

}
